/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package queenb.web.store;

import java.sql.Date;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import oracle.jdbc.OracleTypes;
import queenb.net.datacontrol.DataStatement;
import queenb.net.datacontrol.Param;
import queenb.net.entitybean.V050;
import queenb.web.util.PackageContants;

/**
 *
 * @author VANANH
 */
public class V050Store extends V050 {

    public List<V050> getListCombV050SGT(int pnFH000, int pnFH200, String pvVV051, String pvVV066, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_COMBV050SGT, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV066),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V050Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V050Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V050Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<V050> listV050(int pnFH000, int pnFH200, int pnFV050, int pnFS200, String pvLOGIN) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050SGT, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFV050),
                    new Param(OracleTypes.INTEGER, pnFS200),
                    new Param(OracleTypes.CHAR, pvLOGIN),});
        return super.find(dataStatement, V050.class);
    }

    public List<V050> listV050All(int pnFH000, int pnFH200, int pnFV050, String pvVV066, String pvLOGIN) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050SGT, OracleTypes.CURSOR, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFH000),
                    new Param(OracleTypes.INTEGER, pnFH200),
                    new Param(OracleTypes.INTEGER, pnFV050),
                    new Param(OracleTypes.CHAR, pvVV066),
                    new Param(OracleTypes.CHAR, pvLOGIN),});
        return super.find(dataStatement, V050.class);
    }

    public int deleteV050(int pnFV050, String pvLOGIN) throws SQLException, InstantiationException, IllegalAccessException {
        DataStatement dataStatement = new DataStatement(PackageContants.DELETE_V050, OracleTypes.INTEGER, new Param[]{
                    new Param(OracleTypes.INTEGER, pnFV050),
                    new Param(OracleTypes.CHAR, pvLOGIN)});

        return super.update(dataStatement, V050.class);

    }

    public int stdv_tools_inserttabv050new(int pnPV050,
            String pnVV051,
            String pnVV052,
            int pnVN053,
            int pnVN054,
            Double pnVN055,
            String pvVV067,
            Date pdVD073,
            Date pdVD074,
            int pnVN079,
            int pnFH000,
            int pnFH200,
            int pnFS400,
            int pnFC475,
            int pnFK100,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.stdv_tools_inserttabv050new, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV051),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN055),
                     new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV067),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD073),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD074),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN079),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS400),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFC475),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFK100),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }

    }

    public int updateV050ForS400(int pnPV050,
            int pnFH000,
            int pnFH200,
            int pnFS400,
            String pnVV052,
            int pnVN053,
            int pnVN054,
            int pnVN055,
            String pnVN067,
            String pnVN069,
            String pnVN070,
            Date pdVD073,
            Date pdVD074,
            int pnVN075,
            int pnVN076,
            int pnVN077,
            int pnVN078,
            int pnVN079,
            int pnFA000F,
            int pnFA000T,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.UPDATE_V050_FOR_S400, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS400),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN055),
                       new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN067),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN069),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN070),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD073),
                    new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD074),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN075),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN076),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN077),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN078),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN079),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFA000F),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFA000T),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }

    }

    public int updateV050By(int pnPV050,
            int pnFH000,
            int pnFH200,
            int pnFS200,
            String pvVV051,
            String pvVV052,
            int pnVN053,
            int pnVN054,
            double pnVN055,
            int pnVN056,
            int pnVN057,
            double pnVN058,
            int pnVN059,
            int pnVN060,
            double pnVN061,
            int pnVN062,
            int pnVN063,
            double pnVN064,
            String pnVN065,
            String pnVN066,
            String pvLOGIN) {
        DataStatement dataStetament = new DataStatement(PackageContants.UPDATE_V050, OracleTypes.INTEGER, new queenb.net.datacontrol.Param[]{
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnPV050),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS200),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV052),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN053),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN054),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN055),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN056),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN057),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN058),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN059),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN060),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN061),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN062),
                    new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN063),
                    new queenb.net.datacontrol.Param(OracleTypes.DOUBLE, pnVN064),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN065),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVN066),
                    new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)});
        try {
            return super.update(dataStetament, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return 0;
        }

    }

    public List<V050> getListAllV050SGT(int pnFH000,
            int pnFH200,
            int pnFV050,
            String pnVV066,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV066),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
    public List<V050> getListAllV050SGTN(int pnFH000,
            int pnFH200,
            int pnFV050,
            String pnVV066,
            Date pdVD073,
            Date pdVD074,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050_SGT, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV066),
                        new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD073),
                        new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD074),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<V050> vcurpks_listoftabv050(int pnFH000,
            int pnFH200,
            int pnFV050,
            String pnVV066,
            Date pdVD073,
            Date pdVD074, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.vcurpks_listoftabv050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pnVV066),
                        new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD073),
                        new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD074),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnOFFSET),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnLIMIT),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnSORT),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnDIRECTION),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
    //dung cho tim kiem listtour.jsp

    public List<V050> getListSearchV050A(int pnFH000,
            int pnFH200,
            int pnSDate,
            int pnSMonth,
            int pnSYear,
            int pnFA000F,
            int pnFA000T,
            int pnFN750,
            int pnVN055,
            int pnVN059,
            int pnVN079,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050A, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnSDate),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnSMonth),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnSYear),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFA000F),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFA000T),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFN750),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN055),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN059),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnVN079),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
    // Lịch sử Tour cho khách hàng

    public List<V050> getListAllV030KH(int pnFH000,
            int pnFH200,
            int pnFN100,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050KH, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFN100),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
    //Lịch sử Tour cho công ty

    public List<V050> getListAllV030CT(int pnFH000,
            int pnFH200,
            int pnFK100,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_V050CT, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFK100),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    // Danhs ahch lich su di Tuour cho kahch hnha cong ty 
    public List<V050> getListAllV050CT(int pnFH000,
            int pnFH200,
            int pnFK100,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LIST_TOUR_FORCUSTOMER, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFK100),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    // code
    public List<V050> getListAllV050CODE(int pnFH000,
            int pnFH200,
            String pvVV051,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LISTCODE_V050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<V050> getListAllV050ALL(int pnFH000,
            int pnFH200,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LISTAL_V050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<V050> getListAllV050IO(int pnFH000, int pnFH200, int pnFV050, String pvVV066, String pvNV851, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LISTIO_V050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV066),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvNV851),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<V050> getListAllV050STATUS(int pnFH000, int pnFH200, String pvVV065, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LISTSTATUS_V050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV065),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    public List<V050> getListAllV050NAME(int pnFH000,
            int pnFH200,
            String pvVV051,
            String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.LISTNAME_V050, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV051),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }

    // danh sach Tour moi
    public List<V050> vcurpks_listoftabv050new(int pnFH000,
            int pnFH200, int pnFV050, int pnFS400, int pnFK100, String pvVV065, Date pdVD073, Date pdVD074, int pnOFFSET, int pnLIMIT, int pnSORT, int pnDIRECTION, String pvLOGIN) {
        try {
            DataStatement dataStatement = new DataStatement(PackageContants.vcurpks_listoftabv050new, OracleTypes.CURSOR, new queenb.net.datacontrol.Param[]{
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH000),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFH200),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFV050),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFS400),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnFK100),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvVV065),
                        new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD073),
                        new queenb.net.datacontrol.Param(OracleTypes.DATE, pdVD074),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnOFFSET),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnLIMIT),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnSORT),
                        new queenb.net.datacontrol.Param(OracleTypes.INTEGER, pnDIRECTION),
                        new queenb.net.datacontrol.Param(OracleTypes.CHAR, pvLOGIN)
                    });
            return super.find(dataStatement, V050.class);
        } catch (SQLException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(V500Store.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }
}
